package cn.jy.erp.domain;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ZjkMiddlelibrarydetailQuery {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer pageNo = 1;

    protected Integer startRow;

    protected Integer pageSize = 10;

    protected String fields;

    public ZjkMiddlelibrarydetailQuery() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setPageNo(Integer pageNo) {
        this.pageNo=pageNo;
        this.startRow = (pageNo-1)*this.pageSize;
    }

    public Integer getPageNo() {
        return pageNo;
    }

    public void setStartRow(Integer startRow) {
        this.startRow=startRow;
    }

    public Integer getStartRow() {
        return startRow;
    }

    public void setPageSize(Integer pageSize) {
        this.pageSize=pageSize;
        this.startRow = (pageNo-1)*this.pageSize;
    }

    public Integer getPageSize() {
        return pageSize;
    }

    public void setFields(String fields) {
        this.fields=fields;
    }

    public String getFields() {
        return fields;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andDidIsNull() {
            addCriterion("DID is null");
            return (Criteria) this;
        }

        public Criteria andDidIsNotNull() {
            addCriterion("DID is not null");
            return (Criteria) this;
        }

        public Criteria andDidEqualTo(String value) {
            addCriterion("DID =", value, "did");
            return (Criteria) this;
        }

        public Criteria andDidNotEqualTo(String value) {
            addCriterion("DID <>", value, "did");
            return (Criteria) this;
        }

        public Criteria andDidGreaterThan(String value) {
            addCriterion("DID >", value, "did");
            return (Criteria) this;
        }

        public Criteria andDidGreaterThanOrEqualTo(String value) {
            addCriterion("DID >=", value, "did");
            return (Criteria) this;
        }

        public Criteria andDidLessThan(String value) {
            addCriterion("DID <", value, "did");
            return (Criteria) this;
        }

        public Criteria andDidLessThanOrEqualTo(String value) {
            addCriterion("DID <=", value, "did");
            return (Criteria) this;
        }

        public Criteria andDidLike(String value) {
            addCriterion("DID like", value, "did");
            return (Criteria) this;
        }

        public Criteria andDidNotLike(String value) {
            addCriterion("DID not like", value, "did");
            return (Criteria) this;
        }

        public Criteria andDidIn(List<String> values) {
            addCriterion("DID in", values, "did");
            return (Criteria) this;
        }

        public Criteria andDidNotIn(List<String> values) {
            addCriterion("DID not in", values, "did");
            return (Criteria) this;
        }

        public Criteria andDidBetween(String value1, String value2) {
            addCriterion("DID between", value1, value2, "did");
            return (Criteria) this;
        }

        public Criteria andDidNotBetween(String value1, String value2) {
            addCriterion("DID not between", value1, value2, "did");
            return (Criteria) this;
        }

        public Criteria andTidIsNull() {
            addCriterion("TID is null");
            return (Criteria) this;
        }

        public Criteria andTidIsNotNull() {
            addCriterion("TID is not null");
            return (Criteria) this;
        }

        public Criteria andTidEqualTo(String value) {
            addCriterion("TID =", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotEqualTo(String value) {
            addCriterion("TID <>", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidGreaterThan(String value) {
            addCriterion("TID >", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidGreaterThanOrEqualTo(String value) {
            addCriterion("TID >=", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidLessThan(String value) {
            addCriterion("TID <", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidLessThanOrEqualTo(String value) {
            addCriterion("TID <=", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidLike(String value) {
            addCriterion("TID like", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotLike(String value) {
            addCriterion("TID not like", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidIn(List<String> values) {
            addCriterion("TID in", values, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotIn(List<String> values) {
            addCriterion("TID not in", values, "tid");
            return (Criteria) this;
        }

        public Criteria andTidBetween(String value1, String value2) {
            addCriterion("TID between", value1, value2, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotBetween(String value1, String value2) {
            addCriterion("TID not between", value1, value2, "tid");
            return (Criteria) this;
        }

        public Criteria andDetailnameIsNull() {
            addCriterion("DETAILNAME is null");
            return (Criteria) this;
        }

        public Criteria andDetailnameIsNotNull() {
            addCriterion("DETAILNAME is not null");
            return (Criteria) this;
        }

        public Criteria andDetailnameEqualTo(String value) {
            addCriterion("DETAILNAME =", value, "detailname");
            return (Criteria) this;
        }

        public Criteria andDetailnameNotEqualTo(String value) {
            addCriterion("DETAILNAME <>", value, "detailname");
            return (Criteria) this;
        }

        public Criteria andDetailnameGreaterThan(String value) {
            addCriterion("DETAILNAME >", value, "detailname");
            return (Criteria) this;
        }

        public Criteria andDetailnameGreaterThanOrEqualTo(String value) {
            addCriterion("DETAILNAME >=", value, "detailname");
            return (Criteria) this;
        }

        public Criteria andDetailnameLessThan(String value) {
            addCriterion("DETAILNAME <", value, "detailname");
            return (Criteria) this;
        }

        public Criteria andDetailnameLessThanOrEqualTo(String value) {
            addCriterion("DETAILNAME <=", value, "detailname");
            return (Criteria) this;
        }

        public Criteria andDetailnameLike(String value) {
            addCriterion("DETAILNAME like", value, "detailname");
            return (Criteria) this;
        }

        public Criteria andDetailnameNotLike(String value) {
            addCriterion("DETAILNAME not like", value, "detailname");
            return (Criteria) this;
        }

        public Criteria andDetailnameIn(List<String> values) {
            addCriterion("DETAILNAME in", values, "detailname");
            return (Criteria) this;
        }

        public Criteria andDetailnameNotIn(List<String> values) {
            addCriterion("DETAILNAME not in", values, "detailname");
            return (Criteria) this;
        }

        public Criteria andDetailnameBetween(String value1, String value2) {
            addCriterion("DETAILNAME between", value1, value2, "detailname");
            return (Criteria) this;
        }

        public Criteria andDetailnameNotBetween(String value1, String value2) {
            addCriterion("DETAILNAME not between", value1, value2, "detailname");
            return (Criteria) this;
        }

        public Criteria andBatchnumsIsNull() {
            addCriterion("BATCHNUMS is null");
            return (Criteria) this;
        }

        public Criteria andBatchnumsIsNotNull() {
            addCriterion("BATCHNUMS is not null");
            return (Criteria) this;
        }

        public Criteria andBatchnumsEqualTo(String value) {
            addCriterion("BATCHNUMS =", value, "batchnums");
            return (Criteria) this;
        }

        public Criteria andBatchnumsNotEqualTo(String value) {
            addCriterion("BATCHNUMS <>", value, "batchnums");
            return (Criteria) this;
        }

        public Criteria andBatchnumsGreaterThan(String value) {
            addCriterion("BATCHNUMS >", value, "batchnums");
            return (Criteria) this;
        }

        public Criteria andBatchnumsGreaterThanOrEqualTo(String value) {
            addCriterion("BATCHNUMS >=", value, "batchnums");
            return (Criteria) this;
        }

        public Criteria andBatchnumsLessThan(String value) {
            addCriterion("BATCHNUMS <", value, "batchnums");
            return (Criteria) this;
        }

        public Criteria andBatchnumsLessThanOrEqualTo(String value) {
            addCriterion("BATCHNUMS <=", value, "batchnums");
            return (Criteria) this;
        }

        public Criteria andBatchnumsLike(String value) {
            addCriterion("BATCHNUMS like", value, "batchnums");
            return (Criteria) this;
        }

        public Criteria andBatchnumsNotLike(String value) {
            addCriterion("BATCHNUMS not like", value, "batchnums");
            return (Criteria) this;
        }

        public Criteria andBatchnumsIn(List<String> values) {
            addCriterion("BATCHNUMS in", values, "batchnums");
            return (Criteria) this;
        }

        public Criteria andBatchnumsNotIn(List<String> values) {
            addCriterion("BATCHNUMS not in", values, "batchnums");
            return (Criteria) this;
        }

        public Criteria andBatchnumsBetween(String value1, String value2) {
            addCriterion("BATCHNUMS between", value1, value2, "batchnums");
            return (Criteria) this;
        }

        public Criteria andBatchnumsNotBetween(String value1, String value2) {
            addCriterion("BATCHNUMS not between", value1, value2, "batchnums");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("TYPE is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(String value) {
            addCriterion("TYPE =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(String value) {
            addCriterion("TYPE <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(String value) {
            addCriterion("TYPE >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(String value) {
            addCriterion("TYPE >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(String value) {
            addCriterion("TYPE <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(String value) {
            addCriterion("TYPE <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLike(String value) {
            addCriterion("TYPE like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotLike(String value) {
            addCriterion("TYPE not like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<String> values) {
            addCriterion("TYPE in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<String> values) {
            addCriterion("TYPE not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(String value1, String value2) {
            addCriterion("TYPE between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(String value1, String value2) {
            addCriterion("TYPE not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andPlannumsIsNull() {
            addCriterion("PLANNUMS is null");
            return (Criteria) this;
        }

        public Criteria andPlannumsIsNotNull() {
            addCriterion("PLANNUMS is not null");
            return (Criteria) this;
        }

        public Criteria andPlannumsEqualTo(String value) {
            addCriterion("PLANNUMS =", value, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlannumsNotEqualTo(String value) {
            addCriterion("PLANNUMS <>", value, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlannumsGreaterThan(String value) {
            addCriterion("PLANNUMS >", value, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlannumsGreaterThanOrEqualTo(String value) {
            addCriterion("PLANNUMS >=", value, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlannumsLessThan(String value) {
            addCriterion("PLANNUMS <", value, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlannumsLessThanOrEqualTo(String value) {
            addCriterion("PLANNUMS <=", value, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlannumsLike(String value) {
            addCriterion("PLANNUMS like", value, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlannumsNotLike(String value) {
            addCriterion("PLANNUMS not like", value, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlannumsIn(List<String> values) {
            addCriterion("PLANNUMS in", values, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlannumsNotIn(List<String> values) {
            addCriterion("PLANNUMS not in", values, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlannumsBetween(String value1, String value2) {
            addCriterion("PLANNUMS between", value1, value2, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlannumsNotBetween(String value1, String value2) {
            addCriterion("PLANNUMS not between", value1, value2, "plannums");
            return (Criteria) this;
        }

        public Criteria andPlanunitIsNull() {
            addCriterion("PLANUNIT is null");
            return (Criteria) this;
        }

        public Criteria andPlanunitIsNotNull() {
            addCriterion("PLANUNIT is not null");
            return (Criteria) this;
        }

        public Criteria andPlanunitEqualTo(String value) {
            addCriterion("PLANUNIT =", value, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanunitNotEqualTo(String value) {
            addCriterion("PLANUNIT <>", value, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanunitGreaterThan(String value) {
            addCriterion("PLANUNIT >", value, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanunitGreaterThanOrEqualTo(String value) {
            addCriterion("PLANUNIT >=", value, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanunitLessThan(String value) {
            addCriterion("PLANUNIT <", value, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanunitLessThanOrEqualTo(String value) {
            addCriterion("PLANUNIT <=", value, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanunitLike(String value) {
            addCriterion("PLANUNIT like", value, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanunitNotLike(String value) {
            addCriterion("PLANUNIT not like", value, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanunitIn(List<String> values) {
            addCriterion("PLANUNIT in", values, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanunitNotIn(List<String> values) {
            addCriterion("PLANUNIT not in", values, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanunitBetween(String value1, String value2) {
            addCriterion("PLANUNIT between", value1, value2, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanunitNotBetween(String value1, String value2) {
            addCriterion("PLANUNIT not between", value1, value2, "planunit");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsIsNull() {
            addCriterion("PLANBOXNUMS is null");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsIsNotNull() {
            addCriterion("PLANBOXNUMS is not null");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsEqualTo(String value) {
            addCriterion("PLANBOXNUMS =", value, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsNotEqualTo(String value) {
            addCriterion("PLANBOXNUMS <>", value, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsGreaterThan(String value) {
            addCriterion("PLANBOXNUMS >", value, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsGreaterThanOrEqualTo(String value) {
            addCriterion("PLANBOXNUMS >=", value, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsLessThan(String value) {
            addCriterion("PLANBOXNUMS <", value, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsLessThanOrEqualTo(String value) {
            addCriterion("PLANBOXNUMS <=", value, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsLike(String value) {
            addCriterion("PLANBOXNUMS like", value, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsNotLike(String value) {
            addCriterion("PLANBOXNUMS not like", value, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsIn(List<String> values) {
            addCriterion("PLANBOXNUMS in", values, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsNotIn(List<String> values) {
            addCriterion("PLANBOXNUMS not in", values, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsBetween(String value1, String value2) {
            addCriterion("PLANBOXNUMS between", value1, value2, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andPlanboxnumsNotBetween(String value1, String value2) {
            addCriterion("PLANBOXNUMS not between", value1, value2, "planboxnums");
            return (Criteria) this;
        }

        public Criteria andCustomerIsNull() {
            addCriterion("CUSTOMER is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIsNotNull() {
            addCriterion("CUSTOMER is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerEqualTo(String value) {
            addCriterion("CUSTOMER =", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotEqualTo(String value) {
            addCriterion("CUSTOMER <>", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerGreaterThan(String value) {
            addCriterion("CUSTOMER >", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOMER >=", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerLessThan(String value) {
            addCriterion("CUSTOMER <", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerLessThanOrEqualTo(String value) {
            addCriterion("CUSTOMER <=", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerLike(String value) {
            addCriterion("CUSTOMER like", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotLike(String value) {
            addCriterion("CUSTOMER not like", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerIn(List<String> values) {
            addCriterion("CUSTOMER in", values, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotIn(List<String> values) {
            addCriterion("CUSTOMER not in", values, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerBetween(String value1, String value2) {
            addCriterion("CUSTOMER between", value1, value2, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotBetween(String value1, String value2) {
            addCriterion("CUSTOMER not between", value1, value2, "customer");
            return (Criteria) this;
        }

        public Criteria andBegintimeIsNull() {
            addCriterion("BEGINTIME is null");
            return (Criteria) this;
        }

        public Criteria andBegintimeIsNotNull() {
            addCriterion("BEGINTIME is not null");
            return (Criteria) this;
        }

        public Criteria andBegintimeEqualTo(Date value) {
            addCriterion("BEGINTIME =", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeNotEqualTo(Date value) {
            addCriterion("BEGINTIME <>", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeGreaterThan(Date value) {
            addCriterion("BEGINTIME >", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeGreaterThanOrEqualTo(Date value) {
            addCriterion("BEGINTIME >=", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeLessThan(Date value) {
            addCriterion("BEGINTIME <", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeLessThanOrEqualTo(Date value) {
            addCriterion("BEGINTIME <=", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeIn(List<Date> values) {
            addCriterion("BEGINTIME in", values, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeNotIn(List<Date> values) {
            addCriterion("BEGINTIME not in", values, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeBetween(Date value1, Date value2) {
            addCriterion("BEGINTIME between", value1, value2, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeNotBetween(Date value1, Date value2) {
            addCriterion("BEGINTIME not between", value1, value2, "begintime");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeIsNull() {
            addCriterion("BEGINADDTIME is null");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeIsNotNull() {
            addCriterion("BEGINADDTIME is not null");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeEqualTo(Date value) {
            addCriterion("BEGINADDTIME =", value, "beginaddtime");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeNotEqualTo(Date value) {
            addCriterion("BEGINADDTIME <>", value, "beginaddtime");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeGreaterThan(Date value) {
            addCriterion("BEGINADDTIME >", value, "beginaddtime");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("BEGINADDTIME >=", value, "beginaddtime");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeLessThan(Date value) {
            addCriterion("BEGINADDTIME <", value, "beginaddtime");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeLessThanOrEqualTo(Date value) {
            addCriterion("BEGINADDTIME <=", value, "beginaddtime");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeIn(List<Date> values) {
            addCriterion("BEGINADDTIME in", values, "beginaddtime");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeNotIn(List<Date> values) {
            addCriterion("BEGINADDTIME not in", values, "beginaddtime");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeBetween(Date value1, Date value2) {
            addCriterion("BEGINADDTIME between", value1, value2, "beginaddtime");
            return (Criteria) this;
        }

        public Criteria andBeginaddtimeNotBetween(Date value1, Date value2) {
            addCriterion("BEGINADDTIME not between", value1, value2, "beginaddtime");
            return (Criteria) this;
        }

        public Criteria andNeederIsNull() {
            addCriterion("NEEDER is null");
            return (Criteria) this;
        }

        public Criteria andNeederIsNotNull() {
            addCriterion("NEEDER is not null");
            return (Criteria) this;
        }

        public Criteria andNeederEqualTo(String value) {
            addCriterion("NEEDER =", value, "needer");
            return (Criteria) this;
        }

        public Criteria andNeederNotEqualTo(String value) {
            addCriterion("NEEDER <>", value, "needer");
            return (Criteria) this;
        }

        public Criteria andNeederGreaterThan(String value) {
            addCriterion("NEEDER >", value, "needer");
            return (Criteria) this;
        }

        public Criteria andNeederGreaterThanOrEqualTo(String value) {
            addCriterion("NEEDER >=", value, "needer");
            return (Criteria) this;
        }

        public Criteria andNeederLessThan(String value) {
            addCriterion("NEEDER <", value, "needer");
            return (Criteria) this;
        }

        public Criteria andNeederLessThanOrEqualTo(String value) {
            addCriterion("NEEDER <=", value, "needer");
            return (Criteria) this;
        }

        public Criteria andNeederLike(String value) {
            addCriterion("NEEDER like", value, "needer");
            return (Criteria) this;
        }

        public Criteria andNeederNotLike(String value) {
            addCriterion("NEEDER not like", value, "needer");
            return (Criteria) this;
        }

        public Criteria andNeederIn(List<String> values) {
            addCriterion("NEEDER in", values, "needer");
            return (Criteria) this;
        }

        public Criteria andNeederNotIn(List<String> values) {
            addCriterion("NEEDER not in", values, "needer");
            return (Criteria) this;
        }

        public Criteria andNeederBetween(String value1, String value2) {
            addCriterion("NEEDER between", value1, value2, "needer");
            return (Criteria) this;
        }

        public Criteria andNeederNotBetween(String value1, String value2) {
            addCriterion("NEEDER not between", value1, value2, "needer");
            return (Criteria) this;
        }

        public Criteria andNeednumsIsNull() {
            addCriterion("NEEDNUMS is null");
            return (Criteria) this;
        }

        public Criteria andNeednumsIsNotNull() {
            addCriterion("NEEDNUMS is not null");
            return (Criteria) this;
        }

        public Criteria andNeednumsEqualTo(Integer value) {
            addCriterion("NEEDNUMS =", value, "neednums");
            return (Criteria) this;
        }

        public Criteria andNeednumsNotEqualTo(Integer value) {
            addCriterion("NEEDNUMS <>", value, "neednums");
            return (Criteria) this;
        }

        public Criteria andNeednumsGreaterThan(Integer value) {
            addCriterion("NEEDNUMS >", value, "neednums");
            return (Criteria) this;
        }

        public Criteria andNeednumsGreaterThanOrEqualTo(Integer value) {
            addCriterion("NEEDNUMS >=", value, "neednums");
            return (Criteria) this;
        }

        public Criteria andNeednumsLessThan(Integer value) {
            addCriterion("NEEDNUMS <", value, "neednums");
            return (Criteria) this;
        }

        public Criteria andNeednumsLessThanOrEqualTo(Integer value) {
            addCriterion("NEEDNUMS <=", value, "neednums");
            return (Criteria) this;
        }

        public Criteria andNeednumsIn(List<Integer> values) {
            addCriterion("NEEDNUMS in", values, "neednums");
            return (Criteria) this;
        }

        public Criteria andNeednumsNotIn(List<Integer> values) {
            addCriterion("NEEDNUMS not in", values, "neednums");
            return (Criteria) this;
        }

        public Criteria andNeednumsBetween(Integer value1, Integer value2) {
            addCriterion("NEEDNUMS between", value1, value2, "neednums");
            return (Criteria) this;
        }

        public Criteria andNeednumsNotBetween(Integer value1, Integer value2) {
            addCriterion("NEEDNUMS not between", value1, value2, "neednums");
            return (Criteria) this;
        }

        public Criteria andNeedunitIsNull() {
            addCriterion("NEEDUNIT is null");
            return (Criteria) this;
        }

        public Criteria andNeedunitIsNotNull() {
            addCriterion("NEEDUNIT is not null");
            return (Criteria) this;
        }

        public Criteria andNeedunitEqualTo(String value) {
            addCriterion("NEEDUNIT =", value, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedunitNotEqualTo(String value) {
            addCriterion("NEEDUNIT <>", value, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedunitGreaterThan(String value) {
            addCriterion("NEEDUNIT >", value, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedunitGreaterThanOrEqualTo(String value) {
            addCriterion("NEEDUNIT >=", value, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedunitLessThan(String value) {
            addCriterion("NEEDUNIT <", value, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedunitLessThanOrEqualTo(String value) {
            addCriterion("NEEDUNIT <=", value, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedunitLike(String value) {
            addCriterion("NEEDUNIT like", value, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedunitNotLike(String value) {
            addCriterion("NEEDUNIT not like", value, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedunitIn(List<String> values) {
            addCriterion("NEEDUNIT in", values, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedunitNotIn(List<String> values) {
            addCriterion("NEEDUNIT not in", values, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedunitBetween(String value1, String value2) {
            addCriterion("NEEDUNIT between", value1, value2, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedunitNotBetween(String value1, String value2) {
            addCriterion("NEEDUNIT not between", value1, value2, "needunit");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsIsNull() {
            addCriterion("NEEDBOXNUMS is null");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsIsNotNull() {
            addCriterion("NEEDBOXNUMS is not null");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsEqualTo(String value) {
            addCriterion("NEEDBOXNUMS =", value, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsNotEqualTo(String value) {
            addCriterion("NEEDBOXNUMS <>", value, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsGreaterThan(String value) {
            addCriterion("NEEDBOXNUMS >", value, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsGreaterThanOrEqualTo(String value) {
            addCriterion("NEEDBOXNUMS >=", value, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsLessThan(String value) {
            addCriterion("NEEDBOXNUMS <", value, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsLessThanOrEqualTo(String value) {
            addCriterion("NEEDBOXNUMS <=", value, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsLike(String value) {
            addCriterion("NEEDBOXNUMS like", value, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsNotLike(String value) {
            addCriterion("NEEDBOXNUMS not like", value, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsIn(List<String> values) {
            addCriterion("NEEDBOXNUMS in", values, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsNotIn(List<String> values) {
            addCriterion("NEEDBOXNUMS not in", values, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsBetween(String value1, String value2) {
            addCriterion("NEEDBOXNUMS between", value1, value2, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andNeedboxnumsNotBetween(String value1, String value2) {
            addCriterion("NEEDBOXNUMS not between", value1, value2, "needboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsIsNull() {
            addCriterion("EXCEPTIONNUMS is null");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsIsNotNull() {
            addCriterion("EXCEPTIONNUMS is not null");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsEqualTo(Integer value) {
            addCriterion("EXCEPTIONNUMS =", value, "exceptionnums");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsNotEqualTo(Integer value) {
            addCriterion("EXCEPTIONNUMS <>", value, "exceptionnums");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsGreaterThan(Integer value) {
            addCriterion("EXCEPTIONNUMS >", value, "exceptionnums");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsGreaterThanOrEqualTo(Integer value) {
            addCriterion("EXCEPTIONNUMS >=", value, "exceptionnums");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsLessThan(Integer value) {
            addCriterion("EXCEPTIONNUMS <", value, "exceptionnums");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsLessThanOrEqualTo(Integer value) {
            addCriterion("EXCEPTIONNUMS <=", value, "exceptionnums");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsIn(List<Integer> values) {
            addCriterion("EXCEPTIONNUMS in", values, "exceptionnums");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsNotIn(List<Integer> values) {
            addCriterion("EXCEPTIONNUMS not in", values, "exceptionnums");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsBetween(Integer value1, Integer value2) {
            addCriterion("EXCEPTIONNUMS between", value1, value2, "exceptionnums");
            return (Criteria) this;
        }

        public Criteria andExceptionnumsNotBetween(Integer value1, Integer value2) {
            addCriterion("EXCEPTIONNUMS not between", value1, value2, "exceptionnums");
            return (Criteria) this;
        }

        public Criteria andExceptionunitIsNull() {
            addCriterion("EXCEPTIONUNIT is null");
            return (Criteria) this;
        }

        public Criteria andExceptionunitIsNotNull() {
            addCriterion("EXCEPTIONUNIT is not null");
            return (Criteria) this;
        }

        public Criteria andExceptionunitEqualTo(String value) {
            addCriterion("EXCEPTIONUNIT =", value, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionunitNotEqualTo(String value) {
            addCriterion("EXCEPTIONUNIT <>", value, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionunitGreaterThan(String value) {
            addCriterion("EXCEPTIONUNIT >", value, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionunitGreaterThanOrEqualTo(String value) {
            addCriterion("EXCEPTIONUNIT >=", value, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionunitLessThan(String value) {
            addCriterion("EXCEPTIONUNIT <", value, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionunitLessThanOrEqualTo(String value) {
            addCriterion("EXCEPTIONUNIT <=", value, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionunitLike(String value) {
            addCriterion("EXCEPTIONUNIT like", value, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionunitNotLike(String value) {
            addCriterion("EXCEPTIONUNIT not like", value, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionunitIn(List<String> values) {
            addCriterion("EXCEPTIONUNIT in", values, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionunitNotIn(List<String> values) {
            addCriterion("EXCEPTIONUNIT not in", values, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionunitBetween(String value1, String value2) {
            addCriterion("EXCEPTIONUNIT between", value1, value2, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionunitNotBetween(String value1, String value2) {
            addCriterion("EXCEPTIONUNIT not between", value1, value2, "exceptionunit");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsIsNull() {
            addCriterion("EXCEPTIONBOXNUMS is null");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsIsNotNull() {
            addCriterion("EXCEPTIONBOXNUMS is not null");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsEqualTo(String value) {
            addCriterion("EXCEPTIONBOXNUMS =", value, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsNotEqualTo(String value) {
            addCriterion("EXCEPTIONBOXNUMS <>", value, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsGreaterThan(String value) {
            addCriterion("EXCEPTIONBOXNUMS >", value, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsGreaterThanOrEqualTo(String value) {
            addCriterion("EXCEPTIONBOXNUMS >=", value, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsLessThan(String value) {
            addCriterion("EXCEPTIONBOXNUMS <", value, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsLessThanOrEqualTo(String value) {
            addCriterion("EXCEPTIONBOXNUMS <=", value, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsLike(String value) {
            addCriterion("EXCEPTIONBOXNUMS like", value, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsNotLike(String value) {
            addCriterion("EXCEPTIONBOXNUMS not like", value, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsIn(List<String> values) {
            addCriterion("EXCEPTIONBOXNUMS in", values, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsNotIn(List<String> values) {
            addCriterion("EXCEPTIONBOXNUMS not in", values, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsBetween(String value1, String value2) {
            addCriterion("EXCEPTIONBOXNUMS between", value1, value2, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andExceptionboxnumsNotBetween(String value1, String value2) {
            addCriterion("EXCEPTIONBOXNUMS not between", value1, value2, "exceptionboxnums");
            return (Criteria) this;
        }

        public Criteria andStarttimeIsNull() {
            addCriterion("STARTTIME is null");
            return (Criteria) this;
        }

        public Criteria andStarttimeIsNotNull() {
            addCriterion("STARTTIME is not null");
            return (Criteria) this;
        }

        public Criteria andStarttimeEqualTo(Date value) {
            addCriterion("STARTTIME =", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeNotEqualTo(Date value) {
            addCriterion("STARTTIME <>", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeGreaterThan(Date value) {
            addCriterion("STARTTIME >", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("STARTTIME >=", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeLessThan(Date value) {
            addCriterion("STARTTIME <", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeLessThanOrEqualTo(Date value) {
            addCriterion("STARTTIME <=", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeIn(List<Date> values) {
            addCriterion("STARTTIME in", values, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeNotIn(List<Date> values) {
            addCriterion("STARTTIME not in", values, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeBetween(Date value1, Date value2) {
            addCriterion("STARTTIME between", value1, value2, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeNotBetween(Date value1, Date value2) {
            addCriterion("STARTTIME not between", value1, value2, "starttime");
            return (Criteria) this;
        }

        public Criteria andEndtimeIsNull() {
            addCriterion("ENDTIME is null");
            return (Criteria) this;
        }

        public Criteria andEndtimeIsNotNull() {
            addCriterion("ENDTIME is not null");
            return (Criteria) this;
        }

        public Criteria andEndtimeEqualTo(Date value) {
            addCriterion("ENDTIME =", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotEqualTo(Date value) {
            addCriterion("ENDTIME <>", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeGreaterThan(Date value) {
            addCriterion("ENDTIME >", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ENDTIME >=", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeLessThan(Date value) {
            addCriterion("ENDTIME <", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeLessThanOrEqualTo(Date value) {
            addCriterion("ENDTIME <=", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeIn(List<Date> values) {
            addCriterion("ENDTIME in", values, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotIn(List<Date> values) {
            addCriterion("ENDTIME not in", values, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeBetween(Date value1, Date value2) {
            addCriterion("ENDTIME between", value1, value2, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotBetween(Date value1, Date value2) {
            addCriterion("ENDTIME not between", value1, value2, "endtime");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeIsNull() {
            addCriterion("OVERADDTIME is null");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeIsNotNull() {
            addCriterion("OVERADDTIME is not null");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeEqualTo(Date value) {
            addCriterion("OVERADDTIME =", value, "overaddtime");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeNotEqualTo(Date value) {
            addCriterion("OVERADDTIME <>", value, "overaddtime");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeGreaterThan(Date value) {
            addCriterion("OVERADDTIME >", value, "overaddtime");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("OVERADDTIME >=", value, "overaddtime");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeLessThan(Date value) {
            addCriterion("OVERADDTIME <", value, "overaddtime");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeLessThanOrEqualTo(Date value) {
            addCriterion("OVERADDTIME <=", value, "overaddtime");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeIn(List<Date> values) {
            addCriterion("OVERADDTIME in", values, "overaddtime");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeNotIn(List<Date> values) {
            addCriterion("OVERADDTIME not in", values, "overaddtime");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeBetween(Date value1, Date value2) {
            addCriterion("OVERADDTIME between", value1, value2, "overaddtime");
            return (Criteria) this;
        }

        public Criteria andOveraddtimeNotBetween(Date value1, Date value2) {
            addCriterion("OVERADDTIME not between", value1, value2, "overaddtime");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsIsNull() {
            addCriterion("ENDPRODUCTNUMS is null");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsIsNotNull() {
            addCriterion("ENDPRODUCTNUMS is not null");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsEqualTo(String value) {
            addCriterion("ENDPRODUCTNUMS =", value, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsNotEqualTo(String value) {
            addCriterion("ENDPRODUCTNUMS <>", value, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsGreaterThan(String value) {
            addCriterion("ENDPRODUCTNUMS >", value, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsGreaterThanOrEqualTo(String value) {
            addCriterion("ENDPRODUCTNUMS >=", value, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsLessThan(String value) {
            addCriterion("ENDPRODUCTNUMS <", value, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsLessThanOrEqualTo(String value) {
            addCriterion("ENDPRODUCTNUMS <=", value, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsLike(String value) {
            addCriterion("ENDPRODUCTNUMS like", value, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsNotLike(String value) {
            addCriterion("ENDPRODUCTNUMS not like", value, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsIn(List<String> values) {
            addCriterion("ENDPRODUCTNUMS in", values, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsNotIn(List<String> values) {
            addCriterion("ENDPRODUCTNUMS not in", values, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsBetween(String value1, String value2) {
            addCriterion("ENDPRODUCTNUMS between", value1, value2, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andEndproductnumsNotBetween(String value1, String value2) {
            addCriterion("ENDPRODUCTNUMS not between", value1, value2, "endproductnums");
            return (Criteria) this;
        }

        public Criteria andPickerIsNull() {
            addCriterion("PICKER is null");
            return (Criteria) this;
        }

        public Criteria andPickerIsNotNull() {
            addCriterion("PICKER is not null");
            return (Criteria) this;
        }

        public Criteria andPickerEqualTo(String value) {
            addCriterion("PICKER =", value, "picker");
            return (Criteria) this;
        }

        public Criteria andPickerNotEqualTo(String value) {
            addCriterion("PICKER <>", value, "picker");
            return (Criteria) this;
        }

        public Criteria andPickerGreaterThan(String value) {
            addCriterion("PICKER >", value, "picker");
            return (Criteria) this;
        }

        public Criteria andPickerGreaterThanOrEqualTo(String value) {
            addCriterion("PICKER >=", value, "picker");
            return (Criteria) this;
        }

        public Criteria andPickerLessThan(String value) {
            addCriterion("PICKER <", value, "picker");
            return (Criteria) this;
        }

        public Criteria andPickerLessThanOrEqualTo(String value) {
            addCriterion("PICKER <=", value, "picker");
            return (Criteria) this;
        }

        public Criteria andPickerLike(String value) {
            addCriterion("PICKER like", value, "picker");
            return (Criteria) this;
        }

        public Criteria andPickerNotLike(String value) {
            addCriterion("PICKER not like", value, "picker");
            return (Criteria) this;
        }

        public Criteria andPickerIn(List<String> values) {
            addCriterion("PICKER in", values, "picker");
            return (Criteria) this;
        }

        public Criteria andPickerNotIn(List<String> values) {
            addCriterion("PICKER not in", values, "picker");
            return (Criteria) this;
        }

        public Criteria andPickerBetween(String value1, String value2) {
            addCriterion("PICKER between", value1, value2, "picker");
            return (Criteria) this;
        }

        public Criteria andPickerNotBetween(String value1, String value2) {
            addCriterion("PICKER not between", value1, value2, "picker");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}